Usage Note 60452: The "BRIDGE FAILURE..." error occurs when bulk loading to Microsoft SQL Server in Microsoft Windows 10 operating environments
 |  |  |  |
When using SAS/ACCESS Interface to ODBC, you might receive an error similar to the following:
ERROR: BRIDGE FAILURE - ERROR LOADING IMAGE
MODULE: SASBCP10SASXB
MODULE: SASBCP10SASXB
The problem occurs under the following conditions:
- You use SAS/ACCESS® Interface to ODBC to connect to Microsoft SQL Server.
- You set BULKLOAD=YES.
- You use a Microsoft Windows 10 operating system.
This problem occurs because the following ODBC driver versions have problems with bulk loading:
- the version 10 driver (typically, it is version 10.0.14393.0 or a similar number)
- the version 13 driver (typically, it is version 2015.131.4413.46 or a similar number)
To circumvent the problem, do one of the following:
- Upgrade to SAS® 9.4M5 (TS1M5) of the SAS system and install the latest Microsoft SQL Server Native Client 13 driver.
- Use the INSERTBUFF= option in your LIBNAME statement instead of BULKLOAD=.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to ODBC | Microsoft® Windows® for x64 | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 |
| Microsoft Windows 8 Enterprise x64 | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 | ||
| Microsoft Windows 8 Pro x64 | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Pro 32-bit | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Pro x64 | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 | ||
| Microsoft Windows 10 | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2008 R2 | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2008 for x64 | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 Datacenter | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 R2 Std | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 Std | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 | ||
| Windows 7 Enterprise x64 | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 | ||
| Windows 7 Professional x64 | 9.4 | 9.4_M5 | 9.4 TS1M0 | 9.4 TS1M5 | ||
The "BRIDGE FAILURE..." error can occur when you use SAS/ACCESS® Interface to ODBC with bulk loading on Windows 10. The problem occurs with the default version 10 and 13 drivers. To circumvent the problem, install the latest Microsoft SQL Server Native Client 11.0 drivers.
| Type: | Usage Note |
| Priority: |
| Date Modified: | 2017-05-16 13:41:12 |
| Date Created: | 2017-05-10 12:51:24 |